GrapeCity.Xaml.CalcEngine
Evaluate(Object[]) Method


GrapeCity.CalcEngine.Functions Namespace > CalcMatchFunction Class > Evaluate Method : Evaluate(Object[]) Method

The args contains 2 - 3 items: lookup_value, lookup_array, [match_type].

Lookup_value is the value you use to find the value you want in a table.

Lookup_array is a contiguous range of cells containing possible lookup values. Lookup_array must be an array or an array reference.

[Match_type] is the number -1, 0, or 1. Match_type specifies how to matches lookup_value with values in lookup_array.

Returns the relative position of an item in an array that matches a specified value in a specified order.
Syntax
'Declaration
 
Public Overloads Overrides Function Evaluate( _
   ByVal args() As Object _
) As Object
'Usage
 
Dim instance As CalcMatchFunction
Dim args() As Object
Dim value As Object
 
value = instance.Evaluate(args)
public override object Evaluate( 
   object[] args
)

Parameters

args

The args contains 2 - 3 items: lookup_value, lookup_array, [match_type].

Lookup_value is the value you use to find the value you want in a table.

Lookup_array is a contiguous range of cells containing possible lookup values. Lookup_array must be an array or an array reference.

[Match_type] is the number -1, 0, or 1. Match_type specifies how to matches lookup_value with values in lookup_array.

Return Value

A System.Int32 value that indicates the evaluate result.
See Also

Reference

CalcMatchFunction Class
CalcMatchFunction Members
Overload List